package net.bbtang.website.mapper;

import net.bbtang.website.pojo.UserSmsDTO;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

@Repository("userSMSMapper")
public interface UserSMSMapper {
	
	@Insert("INSERT INTO user_sms (user_id,phone,code,status,create_date,update_date) VALUES(-1,#{phone},#{code},-1,now(),now())")
	void saveUserSms(@Param("phone") String phone,@Param("code") String code);
	
	UserSmsDTO getPhoneByNum(@Param("telphone") String telphone,@Param("phoneNum") String phoneNum);
	
}
